﻿
CREATE PROCEDURE [dbo].[proc_Product_GetListAll]
AS
	Select 
	Id,
	Sort,
	CateOneId,
	(select title from Product_Category where Id=[Product].CateOneId) CateOneName,
	CateTwoId,
	(select title from Product_Category where Id=[Product].CateTwoId) CateTwoName,
	SupplierId,
	(select title from Supplier where Id=[Product].SupplierId) SupplierName,
	Title,
	CostPrice,
	SalePrice,
	Description,
	UpTime,
	SCateOneId,
	(select Title from Finance_Subject_Parent where Id=[Product].SCateOneId) SCateOneName,
	SCateTwoId,
	(select Title from Finance_Subject_Parent where Id=[Product].SCateTwoId) SCateTwoName,
	SubjectId,
	(select Title from Finance_Subject where Id=[Product].SubjectId) SubjectName,
xmfx
	From [Product] Order by CateOneId,CateTwoId,[Sort],SupplierId